Welcome to Loot.co.za!
Sign in / Register |Wishlists & Gift Vouchers |Help | Advanced search
|
Your cart is empty |
|||
Showing 1 - 9 of 9 matches in All Departments
"Joe Celko's Complete Guide to NoSQL" provides a complete overview of non-relational technologies so that you can become more nimble to meet the needs of your organization. As data continues to explode and grow more complex, SQL is becoming less useful for querying data and extracting meaning. In this new world of bigger and faster data, you will need to leverage non-relational technologies to get the most out of the information you have. Learn where, when, and why the benefits of NoSQL outweigh those of SQL with "Joe Celko's Complete Guide to NoSQL." This book covers three areas that make today's new data
different from the data of the past: velocity, volume and variety.
When information is changing faster than you can collect and query
it, it simply cannot be treated the same as static data. Celko will
help you understand velocity, to equip you with the tools to drink
from a fire hose. Old storage and access models do not work for big
data. Celko will help you understand volume, as well as different
ways to store and access data such as petabytes and exabytes. Not
all data can fit into a relational model, including genetic data,
semantic data, and data generated by social networks. Celko will
help you understand variety, as well as the alternative storage,
query, and management frameworks needed by certain kinds of
data.
Joe Celko has looked deep into the code of SQL programmers and
found a consistent and troubling pattern - a frightening lack of
consistency between their individual encoding schemes and those of
the industries in which they operate. This translates into a series
of incompatible databases, each one an island unto itself that is
unable to share information with others in an age of
internationalization and business interdependence. Such
incompatibility severely hinders information flow and the quality
of company data.
SQL for Smarties was hailed as the first book devoted explicitly to the advanced techniques needed to transform an experienced SQL programmer into an expert. Now, 20 years later and in its fifth edition, this classic reference still reigns supreme as the only book written by a SQL master that teaches programmers and practitioners to become SQL masters themselves! These are not just tips and techniques; also offered are the best solutions to old and new challenges. Joe Celko conveys the way you need to think in order to get the most out of SQL programming efforts for both correctness and performance. New to the fifth edition, Joe features new examples to reflect the ANSI/ISO Standards so anyone can use it. He also updates data element names to meet new ISO-11179 rules with the same experience-based teaching style that made the previous editions the classics they are today. You will learn new ways to write common queries, such as finding coverings, partitions, runs in data, auctions and inventory, relational divisions and so forth. SQL for Smarties explains some of the principles of SQL programming as well as the code. A new chapter discusses design flaws in DDL, such as attribute splitting, non-normal forum redundancies and tibbling. There is a look at the traditional acid versus base transaction models, now popular in NoSQL products. You'll learn about computed columns and the DEFERRABLE options in constraints. An overview of the bi-temporal model is new to this edition and there is a longer discussion about descriptive statistic aggregate functions. The book finishes with an overview of SQL/PSM that is applicable to proprietary 4GL vendor extensions.
The demand for SQL information and training continues to grow
with the need for a database behind every website capable of
offering web-based information queries. SQL is the de facto
standard for database retrieval, and if you need to access, update,
or utilize data in a modern database management system, youwill
need SQL to do it. TheSecond Editionof "Joe Celko's Trees and
Hierarchies in SQL for Smarties" covers two new sets of extensions
over three entirelynew chapters and expounds upon the changes that
have occurred in SQL standards since the previous edition's
publication. Benefit from mastering the challenging aspects of
these database applications in SQL as taught by Joe Celko, one of
the most-read SQL authors in the world. *Expert advice from a noted SQL authority and award-winning columnist who has given 10 years of service to the ANSI SQL standards committee *Teaches scores of advanced techniques that can be used with any product, in any SQL environment *Offers graph theory and programming techniques for working around deficiencies and gives insight into real-world challenges"
Perfectly intelligent programmers often struggle when forced to
work with SQL. Why? Joe Celko believes the problem lies with their
procedural programming mindset, which keeps them from taking full
advantage of the power of declarative languages. The result is
overly complex and inefficient code, not to mention lost
productivity.
In this complete revision and expansion of his first SQL Puzzles
book, Joe Celko challenges you with his trickiest puzzles and then
helps solve them with a variety of solutions and explanations. Joe
demonstrates the thought processes that are involved in attacking a
problem from an SQL perspective to help advanced database
programmers solve the puzzles you frequently face. These techniques
not only help with the puzzle at hand, but help develop the mindset
needed to solve the many difficult SQL puzzles you face every day.
Of course, part of the fun is to see whether or not you can write
better solutions than Joe s.
Are you an SQL programmer that, like many, came to SQL after
learning and writing procedural or object-oriented code? Or have
switched jobs to where a different brand of SQL is being used, or
maybe even been told to learn SQL yourself?
Do you need an introductory book on data and databases? If the
book is by Joe Celko, the answer is yes. "Data and Databases:
Concepts in Practice" is the first introduction to relational
database technology written especially for practicing IT
professionals. If you work mostly outside the database world, this
book will ground you in the concepts and overall framework you must
master if your data-intensive projects are to be successful. If
you're already an experienced database programmer, administrator,
analyst, or user, it will let you take a step back from your work
and examine the founding principles on which you rely every
day-helping you to work smarter, faster, and problem-free. Whatever your field or level of expertise, Data and Databases
offers you the depth and breadth of vision for which Celko is
famous. No one knows the topic as well as he, and no one conveys
this knowledge as clearly, as effectively-or as engagingly. Filled
with absorbing war stories and no-holds-barred commentary, this is
a book you'll pick up again and again, both for the information it
holds and for the distinctive style that marks it as genuine
Celko.
Before SQL programmers could begin working with OLTP (On-Line
Transaction Processing) systems, they had to unlearn procedural,
record-oriented programming before moving on to SQL s declarative,
set-oriented programming. This book covers the next step in your
growth. OLAP (On-Line Analytical Processing), Data Warehousing and
Analytics involve seeing data in the aggregate and over time, not
as single transactions. Once more it is time to unlearn what you
were previously taught.
|
You may like...
Beauty And The Beast - Blu-Ray + DVD
Emma Watson, Dan Stevens, …
Blu-ray disc
R326
Discovery Miles 3 260
|